<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="PersonalStatus.aspx.cs" Inherits="PersonalStatus" Title="Tackle - Weekly Personal Status" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentHolder" runat="Server">
    <strong>Weekly Personal Status<br />
        <br />
    </strong><span style="font-size: x-small"><span style="font-size: 8pt">This page allows
        entering of weekly status information related to the sprint and week selected.</span><br />
        <br />
        <table cellpadding="4" cellspacing="0" width="98%">
            <tr>
                <td bgcolor="#e3eaeb" style="border-top: silver 1px ridge; border-left: silver 1px ridge;
                    border-bottom: silver 1px ridge" valign="top" width="33%">
                    <asp:UpdatePanel runat="server" ID="UPSprintSelection">
                        <ContentTemplate>
                        <span style="font-size: x-small">Sprint: </span><asp:DropDownList ID="ddSprintSelection" runat="server" AutoPostBack="True" DataSourceID="dsGetSprintNames"
                                DataTextField="SprintName" DataValueField="SprintID" Font-Size="X-Small" OnDataBound="ddSprintSelection_DataBound"
                                Font-Names="Verdana" OnSelectedIndexChanged="ddSprintSelection_SelectedIndexChanged">
                            </asp:DropDownList>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </td>
                <td bgcolor="#e3eaeb" style="border-top: silver 1px ridge; border-bottom: silver 1px ridge;
                    text-align: center;" valign="top" width="34%">
                    <asp:UpdatePanel runat="server" ID="UPWeekEnding">
                        <ContentTemplate>
                            <span style="font-size: x-small">
                            Week Ending: </span>
                            <asp:DropDownList ID="ddWeekInSprint" runat="server" AutoPostBack="True" Font-Size="X-Small"
                                Font-Names="Verdana" OnSelectedIndexChanged="ddWeekInSprint_SelectedIndexChanged">
                            </asp:DropDownList><span style="font-size: x-small"> </span>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </td>
                <td bgcolor="#e3eaeb" style="border-right: silver 1px ridge; border-top: silver 1px ridge;
                    border-bottom: silver 1px ridge; text-align: right;" valign="top" width="33%">
                    <asp:UpdatePanel runat="server" ID="UPOwner">
                        <ContentTemplate>
                            <span style="font-size: x-small">
                            Owner: </span>
                            <asp:DropDownList ID="ddOwner" runat="server" AutoPostBack="True" DataSourceID="dsTaskOwners"
                                DataTextField="Owner" DataValueField="PersonID" Font-Size="X-Small" Font-Names="Verdana"
                                OnDataBound="ddOwner_DataBound" OnSelectedIndexChanged="ddOwner_SelectedIndexChanged">
                            </asp:DropDownList><span style="font-size: x-small"> </span>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </td>
            </tr>
            <tr>
                <td colspan="3" style="border-left: silver 1px ridge; border-bottom: silver 1px ridge;
                    border-right: silver 1px ridge;" valign="top">
                    <strong>
                        <br />
                        Summary Status Information:</strong><br />
                    <br />
                    <asp:UpdatePanel runat="server" ID="UPDetailsView">
                        <ContentTemplate>
                            <asp:DetailsView ID="dvPersonalStatus" runat="server" AutoGenerateRows="False" CellPadding="4"
                                DataSourceID="dsPersonalStatus" ForeColor="#333333" GridLines="None" OnDataBound="dvPersonalStatus_DataBound"
                                OnPreRender="dvPersonalStatus_PreRender" Width="100%" BorderColor="Gray" BorderStyle="Solid"
                                BorderWidth="1px">
                                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <CommandRowStyle BackColor="#C5BBAF" Font-Bold="True" />
                                <EditRowStyle BackColor="#7C6F57" />
                                <RowStyle BackColor="#E3EAEB" />
                                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                                <Fields>
                                    <asp:TemplateField HeaderText="Most Important Accomplishment This Week" SortExpression="ThisWeek">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox1" runat="server" Font-Names="Verdana" Font-Size="X-Small"
                                                MaxLength="512" Text='<%# Bind("ThisWeek") %>' Width="99%"></asp:TextBox>
                                            <asp:RequiredFieldValidator ID="rfv1e" runat="server" ControlToValidate="TextBox1"
                                                ErrorMessage="*?" Font-Names="Verdana" Font-Size="Small" ForeColor="LightCoral"
                                                ToolTip="This field must contain a valid value less than 512 characters."></asp:RequiredFieldValidator>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="TextBox1" runat="server" Font-Names="Verdana" Font-Size="X-Small"
                                                MaxLength="512" Text='<%# Bind("ThisWeek") %>' Width="99%"></asp:TextBox>
                                            <asp:RequiredFieldValidator ID="rfv1i" runat="server" ControlToValidate="TextBox1"
                                                ErrorMessage="*?" Font-Names="Verdana" Font-Size="Small" ForeColor="LightCoral"
                                                ToolTip="This field must contain a valid value less than 512 characters."></asp:RequiredFieldValidator>
                                        </InsertItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="Label1" runat="server" Text='<%# Bind("ThisWeek") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle Width="30%" VerticalAlign="Top" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Biggest Goal For Next Week" SortExpression="NextWeek">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox2" runat="server" Font-Names="Verdana" Font-Size="X-Small"
                                                MaxLength="512" Text='<%# Bind("NextWeek") %>' Width="99%"></asp:TextBox>
                                            <asp:RequiredFieldValidator ID="rfv2e" runat="server" ControlToValidate="TextBox2"
                                                ErrorMessage="*?" Font-Names="Verdana" Font-Size="Small" ForeColor="LightCoral"
                                                ToolTip="This field must contain a valid value less than 512 characters."></asp:RequiredFieldValidator>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="TextBox2" runat="server" Font-Names="Verdana" Font-Size="X-Small"
                                                MaxLength="512" Text='<%# Bind("NextWeek") %>' Width="99%"></asp:TextBox>
                                            <asp:RequiredFieldValidator ID="rfv2i" runat="server" ControlToValidate="TextBox2"
                                                ErrorMessage="*?" Font-Names="Verdana" Font-Size="Small" ForeColor="LightCoral"
                                                ToolTip="This field must contain a valid value less than 512 characters."></asp:RequiredFieldValidator>
                                        </InsertItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="Label2" runat="server" Text='<%# Bind("NextWeek") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle VerticalAlign="Top" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Blocking Issues" SortExpression="BlockingIssues">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("BlockingIssues") %>' Font-Names="Verdana"
                                                Font-Size="X-Small" Height="36px" TextMode="MultiLine" Width="99%"></asp:TextBox>
                                            <asp:CustomValidator
                                                    ID="cvalidDesc" runat="server" ControlToValidate="TextBox3" ErrorMessage="* Only 2000 chars allowed."
                                                    ForeColor="LightCoral" OnServerValidate="CustValMLMaxLength_ServerValidate" ToolTip="2000"></asp:CustomValidator>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="TextBox3" runat="server" Font-Names="Verdana" Font-Size="X-Small"
                                                Height="36px" Text='<%# Bind("BlockingIssues") %>' TextMode="MultiLine" Width="99%"></asp:TextBox>
                                            <asp:CustomValidator
                                                    ID="cvalidDescI" runat="server" ControlToValidate="TextBox3" ErrorMessage="* Only 2000 chars allowed."
                                                    ForeColor="LightCoral" OnServerValidate="CustValMLMaxLength_ServerValidate" ToolTip="2000"></asp:CustomValidator>
                                        </InsertItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="Label3" runat="server" Text='<%# Bind("BlockingIssues") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle VerticalAlign="Top" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Any Noteworthy News?" SortExpression="News">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox4" runat="server" Font-Names="Verdana" Font-Size="X-Small"
                                                MaxLength="512" Text='<%# Bind("News") %>' Width="99%"></asp:TextBox>&nbsp;
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="TextBox4" runat="server" Font-Names="Verdana" Font-Size="X-Small"
                                                MaxLength="512" Text='<%# Bind("News") %>' Width="99%"></asp:TextBox>&nbsp;
                                        </InsertItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="Label4" runat="server" Text='<%# Bind("News") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle VerticalAlign="Top" />
                                    </asp:TemplateField>
                                    <asp:CommandField ShowEditButton="True" NewText="" ShowInsertButton="True" InsertText="Update" />
                                </Fields>
                                <FieldHeaderStyle BackColor="#D0D0D0" Font-Bold="True" />
                                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <AlternatingRowStyle BackColor="White" />
                            </asp:DetailsView>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                    <strong>
                        <br />
                        <span style="font-size: 8pt"></span></strong>
                    <br />
                    <strong>Work Completed:<br />
                    </strong>
                    <br />
                    <asp:UpdatePanel runat="server" ID="UPGVWorkCompleted">
                        <ContentTemplate>
                            <asp:GridView ID="gvPersonalWorkCompleted" runat="server" AllowSorting="True" AutoGenerateColumns="False"
                                CellPadding="4" DataSourceID="dsPersonalWorkCompleted" Font-Names="Verdana" Font-Size="X-Small"
                                ForeColor="#333333" GridLines="None" Width="100%" BorderColor="Gray" BorderStyle="Solid"
                                BorderWidth="1px" EmptyDataText="No Work Completed" OnRowDataBound="gvPersonalWorkCompleted_RowDataBound" ShowFooter="True">
                                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <EmptyDataRowStyle Font-Names="Verdana" Font-Size="X-Small" ForeColor="#1C5E55" />
                                <Columns>
                                    <asp:TemplateField HeaderText="Date" SortExpression="DailyScrumEntryDate">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DailyScrumEntryDate") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="Label1" runat="server" Text='<%# Bind("DailyScrumEntryDate", "{0:d}") %>'></asp:Label>
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:BoundField DataField="ProductName" HeaderText="Product" SortExpression="ProductName" />
                                    <asp:BoundField DataField="Feature" HeaderText="Feature" SortExpression="Feature" />
                                    <asp:BoundField DataField="Activity" HeaderText="Activity" SortExpression="Activity" />
                                    <asp:BoundField DataField="Task" HeaderText="Task" SortExpression="Task" />
                                    <asp:TemplateField HeaderText="Sum Time" SortExpression="SumActual">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ActualTimeTotal") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <HeaderStyle Wrap="False" HorizontalAlign="Right" />
                                        <ItemTemplate>
                                            <asp:Label ID="Label2" runat="server" Text='<%# Eval("SumActual", "{0:F}") %>'></asp:Label>
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Right" />
                                        <FooterStyle HorizontalAlign="Right" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="OOF" SortExpression="OOF">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("OOF") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:CheckBox ID="chbOOF" runat="server" Checked='<%# Bind("OOF") %>' Enabled="False" />
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Discovered" SortExpression="Discovered">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Discovered") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:CheckBox ID="chbDiscovered" runat="server" Checked='<%# Bind("Discovered") %>'
                                                Enabled="False" />
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:BoundField DataField="Notes" HeaderText="Notes" SortExpression="Notes" />
                                </Columns>
                                <RowStyle BackColor="#E3EAEB" />
                                <EditRowStyle BackColor="#7C6F57" />
                                <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <AlternatingRowStyle BackColor="White" />
                            </asp:GridView>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                    <br />
                    <br />
                    <strong>Remaining Work in Sprint:<br />
                    </strong>
                    <br />
                    <asp:UpdatePanel runat="server" ID="UPGBSprintBacklog">
                        <ContentTemplate>
                            <asp:GridView ID="gvPersonalSprintBacklog" runat="server" AllowSorting="True" AutoGenerateColumns="False"
                                CellPadding="4" DataSourceID="dsPersonalSprintBacklog" Font-Names="Verdana" Font-Size="X-Small"
                                ForeColor="#333333" GridLines="None" Width="100%" BorderColor="Gray" BorderStyle="Solid"
                                BorderWidth="1px" EmptyDataText="No Work Remaining" ShowFooter="True" OnRowDataBound="gvPersonalSprintBacklog_RowDataBound">
                                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <Columns>
                                    <asp:BoundField DataField="ProductName" HeaderText="Product" SortExpression="ProductName" />
                                    <asp:BoundField DataField="Feature" HeaderText="Feature" SortExpression="Feature" />
                                    <asp:BoundField DataField="Activity" HeaderText="Activity" SortExpression="Activity" />
                                    <asp:BoundField DataField="Task" HeaderText="Task" SortExpression="Task" />
                                    <asp:TemplateField HeaderText="Base" SortExpression="BaseTime">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("BaseTime") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="Label1" runat="server" Text='<%# Bind("BaseTime", "{0:F}") %>'></asp:Label>
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Right" />
                                        <HeaderStyle HorizontalAlign="Right" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Actual" SortExpression="ActualTimeTotal">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ActualTimeTotal") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="Label2" runat="server" Text='<%# Bind("ActualTimeTotal", "{0:F}") %>'></asp:Label>
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Right" />
                                        <HeaderStyle HorizontalAlign="Right" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Remaining" SortExpression="RemainingTimeTotal">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("RemainingTimeTotal") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="Label3" runat="server" Text='<%# Bind("RemainingTimeTotal", "{0:F}") %>'></asp:Label>
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Right" />
                                        <FooterStyle HorizontalAlign="Right" />
                                        <HeaderStyle HorizontalAlign="Right" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Punted" SortExpression="PuntedTimeTotal">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("PuntedTimeTotal") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="Label4" runat="server" Text='<%# Bind("PuntedTimeTotal", "{0:F}") %>'></asp:Label>
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Right" />
                                        <HeaderStyle HorizontalAlign="Right" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="OOF" SortExpression="OOF">
                                        <EditItemTemplate>
                                            <asp:Label ID="Label1" runat="server" Text='<%# Eval("OOF") %>'></asp:Label>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:CheckBox ID="chbOOF" runat="server" Checked='<%# Bind("OOF") %>' Enabled="False" />
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Discovered" SortExpression="Discovered">
                                        <EditItemTemplate>
                                            <asp:Label ID="Label2" runat="server" Text='<%# Eval("Discovered") %>'></asp:Label>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:CheckBox ID="chbDiscovered" runat="server" Checked='<%# Bind("Discovered") %>'
                                                Enabled="False" />
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:BoundField DataField="Notes" HeaderText="Notes" SortExpression="Notes" />
                                </Columns>
                                <RowStyle BackColor="#E3EAEB" />
                                <EditRowStyle BackColor="#7C6F57" />
                                <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <AlternatingRowStyle BackColor="White" />
                                <EmptyDataRowStyle Font-Names="Verdana" Font-Size="X-Small" ForeColor="#1C5E55" />
                            </asp:GridView>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </td>
            </tr>
        </table>
    </span>
    <asp:SqlDataSource ID="dsGetSprintNames" runat="server" ConnectionString="<%$ ConnectionStrings:TackleConnectionStringMain %>"
        SelectCommand="SELECT DISTINCT tblMasterBacklogSchedule.SprintName, tblMasterBacklogSchedule.EndDate, tblSprint.SprintID FROM tblSprint LEFT OUTER JOIN tblSprintBacklog ON tblSprint.SprintID = tblSprintBacklog.fSprintID RIGHT OUTER JOIN tblMasterBacklogSchedule ON tblSprint.fMasterBacklogScheduleID = tblMasterBacklogSchedule.MasterBacklogScheduleID WHERE (tblMasterBacklogSchedule.fScrumTeamID = @ScrumTeamID) AND (tblSprintBacklog.fSprintID IS NOT NULL) ORDER BY tblMasterBacklogSchedule.EndDate DESC">
        <SelectParameters>
            <asp:SessionParameter Name="ScrumTeamID" SessionField="ScrumTeamID" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="dsTaskOwners" runat="server" ConnectionString="<%$ ConnectionStrings:TackleConnectionStringMain %>"
        ProviderName="<%$ ConnectionStrings:TackleConnectionStringMain.ProviderName %>"
        SelectCommand="SELECT DISTINCT dbo.tblSprintResources.Person AS Owner, dbo.tblSprintResources.SprintResourcesID AS PersonID&#13;&#10;FROM         dbo.tblSprintBacklog INNER JOIN&#13;&#10;                      dbo.tblSprintResources ON dbo.tblSprintBacklog.TaskOwnerID = dbo.tblSprintResources.SprintResourcesID&#13;&#10;WHERE     (dbo.tblSprintBacklog.fSprintID = @SprintID)&#13;&#10;ORDER BY Person">
        <SelectParameters>
            <asp:ControlParameter ControlID="ddSprintSelection" Name="SprintID" PropertyName="SelectedValue" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="dsPersonalStatus" runat="server" ConnectionString="<%$ ConnectionStrings:TackleConnectionStringMain %>"
        InsertCommand="INSERT INTO tblPersonalStatus(fSprintID, fSprintResourcesID, StatusDate, ThisWeek, NextWeek, BlockingIssues, News) VALUES (@iSprintID, @iSprintResourcesID, @iStatusDate, @ThisWeek, @NextWeek, @BlockingIssues, @News)"
        OldValuesParameterFormatString="original_{0}" ProviderName="<%$ ConnectionStrings:TackleConnectionStringMain.ProviderName %>"
        SelectCommand="SELECT ThisWeek, NextWeek, BlockingIssues, News FROM tblPersonalStatus WHERE (fSprintID = @SprintID) AND (fSprintResourcesID = @SprintResourceID) AND (StatusDate = @StatusDate)"
        UpdateCommand="UPDATE tblPersonalStatus SET ThisWeek = @ThisWeek, NextWeek = @NextWeek, BlockingIssues = @BlockingIssues, News = @News WHERE (fSprintID = @fSprintID) AND (fSprintResourcesID = @fSprintResourcesID) AND (StatusDate = @StatusDate)">
        <SelectParameters>
            <asp:ControlParameter ControlID="ddSprintSelection" Name="SprintID" PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="ddOwner" Name="SprintResourceID" PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="ddWeekInSprint" Name="StatusDate" PropertyName="SelectedValue" />
        </SelectParameters>
        <InsertParameters>
            <asp:ControlParameter ControlID="ddSprintSelection" Name="iSprintID" PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="ddOwner" Name="iSprintResourcesID" PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="ddWeekInSprint" Name="iStatusDate" PropertyName="SelectedValue" />
        </InsertParameters>
        <UpdateParameters>
            <asp:ControlParameter Name="fSprintID" ControlID="ddSprintSelection" PropertyName="SelectedValue" />
            <asp:ControlParameter Name="fSprintResourcesID" ControlID="ddOwner" PropertyName="SelectedValue" />
            <asp:ControlParameter Name="StatusDate" ControlID="ddWeekInSprint" PropertyName="SelectedValue" />
        </UpdateParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="dsPersonalSprintBacklog" runat="server" ConnectionString="<%$ ConnectionStrings:TackleConnectionStringMain %>"
        ProviderName="<%$ ConnectionStrings:TackleConnectionStringMain.ProviderName %>"
        SelectCommand="SELECT TOP (100) PERCENT tblProducts.ProductName, tblMasterBacklog.Feature, tblMasterBacklog.Activity, tblSprintBacklog.Task, tblSprintBacklog.BaseTime * @TimeMult AS BaseTime, tblSprintBacklog.ActualTimeTotal * @TimeMult AS ActualTimeTotal, tblSprintBacklog.RemainingTimeTotal * @TimeMult AS RemainingTimeTotal, tblSprintBacklog.PuntedTimeTotal * @TimeMult AS PuntedTimeTotal, tblSprintBacklog.Notes, tblSprintBacklog.OOF, tblSprintBacklog.Discovered FROM tblProducts INNER JOIN tblMasterBacklog ON tblProducts.ProductID = tblMasterBacklog.fProductID RIGHT OUTER JOIN tblSprintBacklog ON tblMasterBacklog.MasterBacklogID = tblSprintBacklog.fMasterBacklogID WHERE (tblSprintBacklog.fSprintID = @SprintID) AND (tblSprintBacklog.TaskOwnerID = @TaskOwnerID) AND (tblSprintBacklog.RemainingTimeTotal > 0) ORDER BY tblProducts.ProductName, tblMasterBacklog.Feature, tblMasterBacklog.Activity, tblSprintBacklog.Task">
        <SelectParameters>
            <asp:ControlParameter ControlID="ddSprintSelection" Name="SprintID" PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="ddOwner" Name="TaskOwnerID" PropertyName="SelectedValue" />
            <asp:SessionParameter Name="TimeMult" SessionField="SBTimeMult" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="dsPersonalWorkCompleted" runat="server" ConnectionString="<%$ ConnectionStrings:TackleConnectionStringMain %>"
        ProviderName="<%$ ConnectionStrings:TackleConnectionStringMain.ProviderName %>"
        SelectCommand="SELECT TOP (100) PERCENT tblDailyScrumTimeUpdates.DailyScrumEntryDate, tblProducts.ProductName, tblMasterBacklog.Feature, tblMasterBacklog.Activity, tblSprintBacklog.Task, SUM(tblDailyScrumTimeUpdates.ActualTime) * @TimeMult AS SumActual, tblSprintBacklog.Notes, tblSprintBacklog.OOF, tblSprintBacklog.Discovered FROM tblDailyScrumTimeUpdates INNER JOIN tblSprintBacklog ON tblDailyScrumTimeUpdates.fSprintBacklogID = tblSprintBacklog.SprintBacklogID LEFT OUTER JOIN tblProducts INNER JOIN tblMasterBacklog ON tblProducts.ProductID = tblMasterBacklog.fProductID ON tblSprintBacklog.fMasterBacklogID = tblMasterBacklog.MasterBacklogID WHERE (tblSprintBacklog.fSprintID = @SprintID) AND (tblSprintBacklog.TaskOwnerID = @TaskOwnerID) AND (tblDailyScrumTimeUpdates.ActualTime <> 0) AND (tblDailyScrumTimeUpdates.DailyScrumEntryDate BETWEEN DATEADD(day, - 6, @WeekEnd) AND @WeekEnd) GROUP BY tblProducts.ProductName, tblMasterBacklog.Feature, tblMasterBacklog.Activity, tblSprintBacklog.Task, tblSprintBacklog.Notes, tblDailyScrumTimeUpdates.DailyScrumEntryDate, tblSprintBacklog.OOF, tblSprintBacklog.Discovered ORDER BY tblDailyScrumTimeUpdates.DailyScrumEntryDate DESC, tblProducts.ProductName, tblMasterBacklog.Feature, tblMasterBacklog.Activity, tblSprintBacklog.Task">
        <SelectParameters>
            <asp:ControlParameter ControlID="ddSprintSelection" Name="SprintID" PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="ddOwner" Name="TaskOwnerID" PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="ddWeekInSprint" Name="WeekEnd" PropertyName="SelectedValue" />
            <asp:SessionParameter Name="TimeMult" SessionField="SBTimeMult" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>
